Table: Bank Deposits

Table: BKDEP
View: BK0005
Record length: 402
Flags: A R 

Keys: 4

Title  Flags  Fields

Bank Deposit   BANK, DEPOSIT, SERIAL
Bank Fiscal Deposit   M  BANK, FSCYEAR, FSCPERIOD, DEPOSIT, SERIAL
Bank Serial Deposit   BANK, SERIAL, DEPOSIT
Bank Reconciliation Fiscal Depos  M  BANK, RECYEAR, RECPERIOD, DEPOSIT, SERIAL

Fields: 38

Field  Type  Title  Presentation 

BANK  String*8  Bank Code  Mask: %-8N
DEPOSIT  BCD*5.0  Deposit Number   
SERIAL  Long  Serial Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
STATUS  Integer  Deposit Status  List: 4 entries
1=Not posted
2=Void
3=In transit
5=Cleared with bank error
SRCEAPP  String*2  Source Application  Mask: %-2N
DEPTYPE  Integer  Deposit Type  List: 3 entries
1=Deposit
2=EFT
3=Transfer
BTCHNBR  BCD*5.0  Batch Number   
ERRBTCHNBR  BCD*5.0  Error Batch Number   
POSTSEQ  BCD*5.0  Posting Sequence Number   
COMMENT  String*60  Deposit Description   
DEPDATE  Date  Deposit Date   
DEPAMT  BCD*10.3  Functional Posted Batch Total   
PRTAMT  BCD*10.3  Functional Batch Total   
SDEPAMT  BCD*10.3  Posted Batch Total   
SPRTAMT  BCD*10.3  Batch Total   
RATETYPE  String*2  Rate Type  Mask: %-2N
SRCECURN  String*3  Source Currency  Mask: %-3N
RATEDATE  Date  Rate Date   
RATE  BCD*8.7  Rate   
RATESPREAD  BCD*8.7  Rate Spread   
RATEOP  Integer  Rate Operation  List: 3 entries
1=Multiply
2=Divide
0=Not Specified
RECSTATUS  Integer  Reconciliation Status  List: 3 entries
1=Not posted
2=Void
3=In transit
RECSTATCHG  Date  Status Change Date   
RECCOMMENT  String*60  Reconciliation Description   
RECCLEARED  BCD*10.3  Reconciliation Amount Cleared   
FSCYEAR  String*4  Fiscal Year  Mask: %4D
FSCPERIOD  Integer  Fiscal Period  List: 12 entries
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
TTYPE  String*6  Transaction Type  Mask: %-6N
REFERENCE  String*60  Deposit Reference   
GLACCOUNT  String*45  G/L Account  Mask: %-45C
RECDATE  Date  Reconciliation Date   
RECYEAR  String*4  Reconciliation Fiscal Year  Mask: %4D
RECPERIOD  Integer  Reconciliation Fiscal Period  List: 12 entries
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
RECONCILED  Boolean  Reconciled   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.